package com.hurl.waguji.biz.collect;

import java.util.Date;

import com.hurl.waguji.base.SqlReader;
import com.hurl.waguji.base.dao.HibernateDao;
import com.hurl.waguji.base.dao.HibernateService;

public class ExecuteProcedureProcess implements CollectProcess{

	private Date rq = null;
	public ExecuteProcedureProcess(Date rq){
		this.rq = rq;
	}
	@Override
	public void execute() {
		HibernateDao dao = HibernateService.getDao();
		dao.queryBySQL(SqlReader.getSql("PROC12050101")).setParameter(0, rq).executeUpdate();
		dao.queryBySQL(SqlReader.getSql("PROC12051601")).setParameter(0, rq).executeUpdate();
		dao.queryBySQL(SqlReader.getSql("PROC12061501")).setParameter(0, rq).executeUpdate();
		dao.flush();
		dao.clear();
	
	}

}
